Boomi for SAP connection

Boomi for SAP connector securely links your SAP system with Data Integration. This connection lets you ingest complete data at a multi-table scale with Boomi for SAP views and Event Streams, ensuring fast, accurate, and duplicate-free data loads into any supported data warehouse or data lake.

Prerequisites

• An active Boomi for SAP account.
• Create the Boomi for SAP table services and finalize them in Boomi for SAP before you connect the source.
• A SAP/Boomi user with access to the views you are replicating.

Procedure

1. Log in to the Data Integration Console.
2. Go to Connections from the left-hand menu.
3. Click + New Connection.
4. In the search box, type Boomi for SAP, and select it. The Create Boomi for SAP Connection dialog appears.
5. Enter a Connection Name.
6. In Host and Port, enter the SAP system host and port.
7. In SAP Client, enter the client number.
8. In Username and Password, enter the credentials for your SAP or Boomi account.
9. Click Save and click Test Connection. If the connection is successful, it is available for use within Data Integration.

Establishing an SSH connection

If your Boomi for SAP database is hosted on an on-premises server, use SSH tunneling to establish a secure connection.

Prerequisites

• Configure your SSH tunnel server to accept connections from Data Integration IP addresses.
• Ensure the SSH tunnel can connect to your Boomi for SAP database using the internal IP address.

Procedure

1. Log in to the Data Integration console.
2. Go to Connections from the left-hand menu.
3. In the search box, type Boomi for SAP, and select it. The Create Boomi for SAP Connection dialog appears.
4. In the connection dialog, switch the SSH Tunnel toggle to On. The SSH configuration fields appear.
5. In the SSH Credentials section, configure the following details:
   • SSH Port: Enter the port number for the SSH connection. The default is 22.
   • SSH Hostname: Enter the internal hostname of the SSH tunnel server.
   • SSH Remote User Name: Enter the username used to authenticate the SSH connection.
6. In the SSH Tunnel section, ensure Upload PEM is selected and configure the following:
   • SSH Connection Key File (Pub/Pem): Drag and drop your private key file (.pem) into the designated area, or click Browse for a file to upload it.
   • SSH KEY File Password: (Optional) If your private key is password-protected, enter the password here.
7. Click Save and click Test Connection. If the connection is successful, it is available for use within Data Integration.